123456/PO PHP H5/Timme - Jisse/gamemakersdetails.php

<?php include('db1.php'); ?> <head> <link rel="stylesheet" href="style.css"> </head> <body> <?php $bedrijfid = $_GET['bedrijfid']; $query = "select * from Gamemakers where bedrijfid = $bedrijfid order by Naam_game "; $result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query"); $row = mysqli_fetch_array($result); echo "<h1>Gamemaker: $row[Naam_game] </h1>"; echo "<h3> Oprichtjaar: $row[Jaar_opgericht], Stad hoofdkantoor: $row[Plaats], Ceo:$row[Ceo] </h3>"; $query = "select * from games where bedrijfid = $bedrijfid order by naam"; $result = mysqli_query($db1, $query) or die(mysqli_error($db1) .": $query"); echo "<div class=knoppen> "; while($row = mysqli_fetch_array($result)){ echo "<h2><a href='games.php?Gameid=$row[Gameid]'> $row[naam]</a></h2>"; } echo "</div>"; echo "<h2 class=hoofdpagina><a href='index.php'> hoofdpagina</a></h2>"; ?> </body> </html>

Resultaat

Made by Thijs Aarnoudse